<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="CurrencyEx.aspx.vb" Inherits="Default2" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <span style="font-family: 'Courier New'; font-size: xx-large"><strong>
    <span style="text-decoration: underline">View 
    Currency Bookings Details</span><br />
    <br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        BorderStyle="Solid" CellPadding="4" 
        DataKeyNames="FirstName,LastName,Postcode,Currency_Booked,Units,Delivered,Remarks" 
        DataSourceID="SqlDataSource1" ForeColor="#333333" style="font-size: medium">
        <AlternatingRowStyle BackColor="White" BorderColor="Black" />
        <Columns>
            <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="LastName" 
                SortExpression="LastName" />
            <asp:BoundField DataField="Postcode" HeaderText="Postcode" 
                SortExpression="Postcode" />
            <asp:BoundField DataField="Currency_Booked" HeaderText="Currency Booked" 
                SortExpression="Currency_Booked" />
            <asp:BoundField DataField="Units" HeaderText="Units" SortExpression="Units" />
            <asp:BoundField DataField="Delivered" HeaderText="Delivered" 
                SortExpression="Delivered" />
            <asp:BoundField DataField="Remarks" HeaderText="Remarks" 
                SortExpression="Remarks" />
        </Columns>
        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#FFCC66" BorderColor="Black" Font-Bold="True" 
            ForeColor="Navy" />
        <SortedAscendingCellStyle BackColor="#FDF5AC" />
        <SortedAscendingHeaderStyle BackColor="#4D0000" />
        <SortedDescendingCellStyle BackColor="#FCF6C0" />
        <SortedDescendingHeaderStyle BackColor="#820000" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:AllAboutForexDBConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:AllAboutForexDBConnectionString.ProviderName %>" 
        SelectCommand="SELECT [FirstName], [LastName], [Postcode], [Currency_Booked], [Units], [Delivered], [Remarks] FROM [Book_Currency] WHERE ([LoginID] = ?)">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="" Name="LoginID" SessionField="LoggedUser" 
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    </strong></span>
</asp:Content>

